DS/CMPSC 410 - Mini Project

Crime Analysis in Chicago City.

Instructor: Professor Romit Maulik

Team Members:

- Sai Sanwariya Narayan

- Nikhil Melligeri

- Shafwat Mustafa

- Rohan Singh

- Shengdi You

- Daniel Gao

- Nathan Quint

Importing Packages

Uploading 2022 Crime Data

Uploading 2023 Crime Data

Data Merging with 2022 - 2023

Removing rows with null values

Map-Reduce for data analysis

Visualization - Primary type and count

Horizontal Graph

Pie Graph

Categorising the Crime according to Primary Type, Description and Location Description

Interactive Tree Map for Categorized Crime

Key-Value pairing for Data and Time

Graphs to show the crime counts by hour

MapReduce to count arrests for each type of crime

Map Reduce for crime type in Community Area - Chicago city has 77 Communities

Heat Map according to Community Areas, Type of crime and count

Spark stop